<!DOCTYPE html>
<html lang="en">
	<head>
		<meta charset="utf-8"/>
		<title>生产日报表</title>
		<meta name="viewport" content="width=device-width, initial-scale=1"/>
		<meta http-equiv="X-UA-Compatible" content="IE=edge" />
		<meta http-equiv="pragma" content="no-cache"/>
		<meta http-equiv="cache-control" content="no-cache"/>
		<meta http-equiv="expires" content="0"/>	
		<link rel="stylesheet" href="./4/lumen/bootstrap.css" media="screen"/>
		<link rel="stylesheet" href="./_assets/css/custom.min.css"/>
	</head>
<body>
	
	

	
	<div class="container">
		<legend>生产日报表</legend>
		<form action="SD2CSV.php" method="post">
			开始时间: <input type="date" name="sjj1"/>
			结束时间: <input type="date" name="sjj2"/>
			<!-- 工單號: <input type="text" name="GongDan"/> -->
			<label><input name="Fruit[]" type="checkbox" value="齐纳" />齐纳 </label> 
			<label><input name="Fruit[]" type="checkbox" value="固晶" />固晶 </label> 
			<label><input name="Fruit[]" type="checkbox" value="焊线" />焊线 </label> 
			<label><input name="Fruit[]" type="checkbox" value="点胶" />点胶 </label> 
			<label><input name="Fruit[]" type="checkbox" value="切割" />切割 </label> 
			<label><input name="Fruit[]" type="checkbox" value="分光" />分光 </label> 
			<label><input name="Fruit[]" type="checkbox" value="编带" />编带 </label> 
			
			<input type="submit" value="导出"/>
			<input type="submit" formaction="WIP2CSV.php" value="WIP表导出"/>
			<br/>(提示:要同時指定開始時間和結束時間才能導出)
		</form>
		
		<br/>
		<br/>
		<div class="form-group row">
			<label class="col-sm-1 col-form-label" for="inputDefault">工序:</label>
			<div class="col-sm-2">
				<select name="WP" class="form-control" id="WP" type="text">
					<option value="齐纳">齐纳</option>
					<option value="固晶">固晶</option>
					<option value="焊线">焊线</option>
					<option value="点胶">点胶</option>
					<option value="切割">切割</option>
					<option value="分光">分光</option>
					<option value="编带">编带</option>
				</select>
			</div>
			<label class="col-sm-1 col-form-label" for="inputDefault">班別:</label>
			<div class="col-sm-1">
				<input type="radio" class="form-check-input" name="classRadios" id="optionsRadios1" value="A"/>
				<label class="custom-control-label" for="customRadio1">白</label><br/>
				<input type="radio" class="form-check-input" name="classRadios" id="optionsRadios2" value="B"/>
				<label class="custom-control-label" for="customRadio1">夜</label>
			</div>
			<label class="col-sm-1 col-form-label" for="inputDefault">提示:</label>
			<div class="col-sm-4">
				<input readonly="" class="form-control"  id="ZT" type="text"/>
			</div>
			<!-- <button type="button" id="ChaXun" >查詢今天排配</button> -->
			<!-- 2018-3-14 16:27:31注釋:PHP要切開 -->
			<!-- <button type="button" id="ChaXun2" >查昨天B班排配</button> -->
			<!-- <button type="button" id="DaoChu" >導出</button> -->
		</div>	
		
		<div class="form-group row">
			<label class="col-sm-1 col-form-label" for="inputDefault">日期:</label>
			<div class="col-sm-2">
				<input readonly="" class="form-control"  id="RiQi" type="text"/>
			</div>

			<label class="col-sm-1 col-form-label" for="inputDefault">周別:</label>
			<div class="col-sm-1">
				<input readonly="" class="form-control"  id="ZhouBie" type="text"/>
			</div>

			<label class="col-sm-1 col-form-label" for="inputDefault">製表人:</label>
			<div class="col-sm-2">
				<input   class="form-control"  id="ZhiBiao" type="text"/>
			</div>
			<button type="button" id="ChaXun" >查製表人</button>
		</div>
		
		<!-- 这里放筛选器 -->
		<button id="ShaiXuanBT">筛选机台号</button>
		<div id="ShaiXuan"></div>
		
		<!-- 这里是JExcel的表格位置 -->
		<div id="mytable"></div>
		
		<div class="form-group row">
			<div class="col-sm-2">
			</div>
			<div class="col-sm-2">
			</div>
			<div class="col-sm-2">
			</div>
			<div class="col-sm-2">
			</div>
			<div class="col-sm-2">
				<button type="button" id="keep" >保存</button>
			</div>
			<div class="col-sm-2">
				<button type="button" id="save" >提交</button>
			</div>
		</div>
		<div class="form-group row">
		</div>
		
		<p class="lead">
			<a class="btn btn-primary btn-lg" href="index.html" role="button">返回</a>
		</p>
	</div>
	
	<link rel="stylesheet" type="text/css" href="./jexcel-master/dist/css/jquery.jexcel.css" />
    <script src="./_vendor/jquery/dist/jquery.min.js"></script>
	<script src="./jexcel-master/dist/js/jquery.jexcel.js"></script>
    <script src="./_vendor/popper.js/dist/umd/popper.min.js"></script>
    <script src="./_vendor/bootstrap/dist/js/bootstrap.min.js"></script>
    <script src="./_assets/js/custom.js"></script>
	
<script>
	
	var Plan_data = null; 
	
	var DuXie = [
		{ type:'text', readOnly:true },
		{ type:'text', readOnly:true },
		{ type:'text', readOnly:true },
		{ type:'text', readOnly:true },
		{ type:'text', readOnly:true },
		{ type:'text', readOnly:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true },
		{ type:'text', wordWrap:true }
	];
	var LieMing = [
		'表深<br/>ID',
		'表头<br/>ID',
		'訂單號',
		'產品型號',
		'產品<br/>類型',
		'產品<br/>系列',
		'工单号',
		'机台号',
		'計劃<br/>產能<br/>(K)',
		'排配<br/>工時<br/>(分钟)',
		'操作员<br/>(姓名)',
		'实际<br/>產能<br/>(K)',
		'实际<br/>工时<br/>(分钟)',
		'UPH<br/>(K/H)',
		'待排配<br/>(待機)',
		'日點檢<br/>保養',
		'工單<br/>切換<br/>調机',
		'更換<br/>耗材',
		'冶具<br/>清理',
		'首件',
		'生產<br/>調机',
		'工程<br/>試樣',
		'設備<br/>故障<br/>停機',
		'品質<br/>異常<br/>停線',
		'待料',
		'水電氣<br/>異常',
		'其他<br/>計劃外<br/>停機',
		'未達成原因備註'
	];
	var LieKuan = [
		40,
		40,
		60,
		100,
		50,
		50,
		100,
		150,
		60,
		80,
		80,
		80,
		50,
		80,
		60,
		50,
		50,
		50,
		50,
		50,
		50,
		50,
		50,
		50,
		50,
		50,
		50,
		200
	]
	
	
	
	var longdata = new Array
	
	var date = new Date;
	var mm = "";
	var dd = "";
	
	var GongXu = encodeURI($("#WP").val());//工序
	var BanBie = $('input[type="radio"][name="classRadios"]:checked').val();//$("#optionsRadios2").val();//班別
	var ZhiBiao = encodeURI($("#ZhiBiao").val());//製表人
	
	//console.log(BanBie);//輸出undefined
	//	2018-3-16 11:55:49
   /*	JExcel的工作:
	*	禁止刪列:在刪除列時,提示禁止刪除列
	*	禁止移動列:在移動列時,提示禁止移動列
	*	機台號,工單號為空時,提示禁止為空
	*	行為空時,測試後端是否會接收到*/
	
	$('#mytable').jexcel({ data:Plan_data,
		// Allow column delete
		allowDeleteColumn:false,
		// Allow row dragging
		rowDrag:false,
		columns:DuXie,
		colHeaders:LieMing,
		colWidths:LieKuan
	});
	
	$(document).ready(function (){
		GongXu = encodeURI($("#WP").val());//工序
		BanBie = $('input[type="radio"][name="classRadios"]:checked').val();//班別
		ZhiBiao = encodeURI($("#ZhiBiao").val());//製表人
		if (BanBie===undefined || ZhiBiao===""){
			$("#ZhiBiao").focus();
			alert("請選擇工序和班別并輸入製表人姓名!");
			$("#ZT").val("請選擇工序和班別并輸入製表人姓名!");
			return ;
		}
		//已剪到後面去了
	});
	
	$("#ChaXun").click(function(){
		GongXu = encodeURI($("#WP").val());//工序
		BanBie = $('input[type="radio"][name="classRadios"]:checked').val();//班別
		ZhiBiao = encodeURI($("#ZhiBiao").val());//製表人
		if (BanBie===undefined || ZhiBiao===""){
			$("#ZhiBiao").focus();
			alert("請選擇工序和班別并輸入製表人姓名!");
			$("#ZT").val("請選擇工序和班別并輸入製表人姓名!");
			return ;
		}
		
		$.ajax({ url: "getPlanNEW.php?GongXu="+GongXu+"&BanBie="+BanBie+"&ZhiBiao="+ZhiBiao, //按製表人查詢
			dataType : "json",
			success: function(data){
				Plan_data = data;
				$('#mytable').jexcel({ data:Plan_data,
					// Allow column delete
					allowDeleteColumn:false,
					// Allow row dragging
					rowDrag:false,
					columns:DuXie,
					colHeaders:LieMing,
					colWidths:LieKuan
				});
				//console.log(Plan_data);
			}
		});
	});
	
	$("#keep").click(function(){
	    GongXu = encodeURI($("#WP").val());//工序
		BanBie = $('input[type="radio"][name="classRadios"]:checked').val();//班別
		ZhiBiao = encodeURI($("#ZhiBiao").val());//製表人
		if (BanBie===undefined || ZhiBiao===""){
			$("#ZhiBiao").focus();
			alert("請選擇工序和班別并輸入製表人姓名!");
			$("#ZT").val("請選擇工序和班別并輸入製表人姓名!");
			return ;
		}
		
		longdata = $('#mytable').jexcel('getData', false); 
		
		//JS FOR語法: for (var i=0,len=cars.length; i<len; i++)
		for (var i=0, len=longdata.length; i<len; i++){
			if(longdata[i][6] === "" || longdata[i][7] === ""){//6工單號或7機台號其中一個空白
				alert("不允許為空,請輸入工單號和機台號!");
				$("#ZT").val("不允許為空,請輸入工單號和機台號!");
				return ;
			}
		}
	    //用逗點隔開的字串
		$.ajax({ 
			type:'POST',
			url: "keepNEW.php",//POST傳一個超長字串到後端
			data:"GongXu="+GongXu+"&BanBie="+BanBie+"&ZhiBiao="+ZhiBiao+"&ShuZu="+JSON.stringify(longdata),
			dataType : "json",
			success: function(data){
				alert("保存成功!"); 
				$("#ZT").val("保存成功!");
				
				Plan_data = data;
				$('#mytable').jexcel({ data:Plan_data,
					// Allow column delete
					allowDeleteColumn:false,
					// Allow row dragging
					rowDrag:false,
					columns:DuXie,
					colHeaders:LieMing,
					colWidths:LieKuan
				});
			}
		});
	});
	
	$("#optionsRadios1").click(function(){
		if ($('input[type="radio"][name="classRadios"]:checked').val()==="A"){
			date = new Date;
			if ((date.getMonth()+1)>9){
				mm=(date.getMonth()+1);
			}else{
				mm=0+""+(date.getMonth()+1);
			};
			if ((date.getDate())>9){
				dd=(date.getDate());
			}else{
				dd=0+""+(date.getDate());
			};
			$("#RiQi").val(date.getFullYear()+"-"+mm+"-"+dd);
			$("#ZhouBie").val(getWeekOfYear(date));
		}
	})
	
	$("#optionsRadios2").click(function(){
		if ($('input[type="radio"][name="classRadios"]:checked').val()==="B"){
			date = new Date;
			if(date.getHours()<20){
				date.setDate(date.getDate()-1);
				if ((date.getMonth()+1)>9){
					mm=(date.getMonth()+1);
				}else{
					mm=0+""+(date.getMonth()+1);
				};
				if ((date.getDate())>9){
					dd=(date.getDate());
				}else{
					dd=0+""+(date.getDate());
				};
				$("#RiQi").val(date.getFullYear()+"-"+mm+"-"+dd);
				$("#ZhouBie").val(getWeekOfYear(date));
			}else{
				if ((date.getMonth()+1)>9){
					mm=(date.getMonth()+1);
				}else{
					mm=0+""+(date.getMonth()+1);
				};
				if ((date.getDate())>9){
					dd=(date.getDate());
				}else{
					dd=0+""+(date.getDate());
				};
				$("#RiQi").val(date.getFullYear()+"-"+mm+"-"+dd);
				$("#ZhouBie").val(getWeekOfYear(date));
			}
		}
	})
	
	//change輸入框改變的方程
	$("#ZhiBiao").change(function(){
		if ($("#ZhiBiao").val()===""){
			$("#ZhiBiao").focus();
			alert("請輸入製表人姓名!");
			$("#ZT").val("請輸入製表人姓名!");
			return;
		}
	});
	
	//blur 失去焦點的事件
	$("#ZhiBiao").blur(function(){
		if ($("#ZhiBiao").val()===""){
			$("#ZhiBiao").focus();
			return;
		}
	});
	
	//湊默認日期(因為JS沒有日期格式化函數)
	
	if ((date.getMonth()+1)>9){
		mm=(date.getMonth()+1);
	}else{
		mm=0+""+(date.getMonth()+1);
	};
	if ((date.getDate())>9){
		dd=(date.getDate());
	}else{
		dd=0+""+(date.getDate());
	};
	//2018-3-8
	//2018-03-08
	$("#RiQi").val(date.getFullYear()+"-"+mm+"-"+dd);
	
	$("#ZhouBie").val(getWeekOfYear(date));
	
	
	//一天含86,400,000毫秒(24*60*60*1000)
	//公式計算获取本周是一年中的第几周
	function getWeekOfYear(date){
	    var d1 = date;
	    var d2 = new Date(date.getFullYear(), 0, 1);
	    var d = Math.round((d1 - d2) / 86400000);
	    return Math.ceil((d + ((d2.getDay() + 1) - 1)) / 7);
	};
	
	//按下筛选按钮后运行
	var html = "";
	$("#ShaiXuanBT").click(function(){
		longdata = $('#mytable').jexcel('getData', false); 
		for(var i = 0; i < longdata.length; i++){//按下按钮后,开始凑新的唯一值数组(用到的是字典功能)
			var res = [];
			var json = {};
			if(!json[longdata[i][8]]){
				res.push(longdata[i][8]);
				json[longdata[i][8]] = 1;
			}
		};
		
		for(var i = 0; i < res.length; i++){
			html += "<tr><input name='JiTai[]' type='checkbox' value='" + res[i] + "' />" + res[i] + " </tr> ";
		};
		
		html = "<table>" + html + "</table>";
		//然后把表格append出去
		$("#ShaiXuan").append(html);
	});
</script>
	
</body>
</html>
